Tabela LPerfServiceStatus

Definicja tabeli LPerfServiceStatus

Name

LPerfServiceStatus

Code

LPerfServiceStatus

Comment

PL: Ustalenie stuatus uslugi
EN: Performed service status assignation


Lista kolumn tabeli LPerfServiceStatus

Name

Code

LPerfServiceStatusID

LPerfServiceStatusID

PerfServiceStatusID

PerfServiceStatusID

PerfServiceID

PerfServiceID

VisitCancelReasonID

VisitCancelReasonID

UserTypeID

UserTypeID

AuthorisationRuleID

AuthorisationRuleID

ActionCodeID

ActionCodeID

PatientStatusID

PatientStatusID

AuthorisationSignID

AuthorisationSignID

PersonID

PersonID

StartDT

StartDT

Reason

Reason

InsertDT

InsertDT

ChangeServiceReasonID

ChangeServiceReasonID

ReasonID

ReasonID


Kolumna LPerfServiceStatusID tabeli LPerfServiceStatus

Definicja kolumny LPerfServiceStatusID tabeli LPerfServiceStatus

Name

LPerfServiceStatusID

Code

LPerfServiceStatusID

Data Type

NUMBER(10)

Mandatory

Yes

Comment

 


Kolumna PerfServiceStatusID tabeli LPerfServiceStatus

Definicja kolumny PerfServiceStatusID tabeli LPerfServiceStatus

Name

PerfServiceStatusID

Code

PerfServiceStatusID

Data Type

NUMBER(10)

Mandatory

Yes

Comment

 


Kolumna PerfServiceID tabeli LPerfServiceStatus

Definicja kolumny PerfServiceID tabeli LPerfServiceStatus

Name

PerfServiceID

Code

PerfServiceID

Data Type

NUMBER(10)

Mandatory

Yes

Comment

 


Kolumna VisitCancelReasonID tabeli LPerfServiceStatus

Definicja kolumny VisitCancelReasonID tabeli LPerfServiceStatus

Name

VisitCancelReasonID

Code

VisitCancelReasonID

Data Type

NUMBER(10)

Mandatory

No

Comment

 


Kolumna UserTypeID tabeli LPerfServiceStatus

Definicja kolumny UserTypeID tabeli LPerfServiceStatus

Name

UserTypeID

Code

UserTypeID

Data Type

NUMBER(10)

Mandatory

No

Comment

 


Kolumna AuthorisationRuleID tabeli LPerfServiceStatus

Definicja kolumny AuthorisationRuleID tabeli LPerfServiceStatus

Name

AuthorisationRuleID

Code

AuthorisationRuleID

Data Type

NUMBER(10)

Mandatory

No

Comment

ID reguly autoryzacji


Kolumna ActionCodeID tabeli LPerfServiceStatus

Definicja kolumny ActionCodeID tabeli LPerfServiceStatus

Name

ActionCodeID

Code

ActionCodeID

Data Type

NUMBER(10)

Mandatory

No

Comment

 


Kolumna PatientStatusID tabeli LPerfServiceStatus

Definicja kolumny PatientStatusID tabeli LPerfServiceStatus

Name

PatientStatusID

Code

PatientStatusID

Data Type

NUMBER(10)

Mandatory

No

Comment

 


Kolumna AuthorisationSignID tabeli LPerfServiceStatus

Definicja kolumny AuthorisationSignID tabeli LPerfServiceStatus

Name

AuthorisationSignID

Code

AuthorisationSignID

Data Type

NUMBER(10)

Mandatory

No

Comment

 


Kolumna PersonID tabeli LPerfServiceStatus

Definicja kolumny PersonID tabeli LPerfServiceStatus

Name

PersonID

Code

PersonID

Data Type

NUMBER(10)

Mandatory

No

Comment

 


Kolumna StartDT tabeli LPerfServiceStatus

Definicja kolumny StartDT tabeli LPerfServiceStatus

Name

StartDT

Code

StartDT

Data Type

DATE

Mandatory

No

Comment

PL: Data poczatku
EN: Start date
DE: das Beginndatum


Kolumna Reason tabeli LPerfServiceStatus

Definicja kolumny Reason tabeli LPerfServiceStatus

Name

Reason

Code

Reason

Data Type

VARCHAR2(268)

Mandatory

No

Comment

 


Kolumna InsertDT tabeli LPerfServiceStatus

Definicja kolumny InsertDT tabeli LPerfServiceStatus

Name

InsertDT

Code

InsertDT

Data Type

DATE

Mandatory

No

Comment

PL: Data wstawienia rekordu
EN: Insert date of record
DE: Das Date der Ansatzstelle fur den Rekord


Kolumna ChangeServiceReasonID tabeli LPerfServiceStatus

Definicja kolumny ChangeServiceReasonID tabeli LPerfServiceStatus

Name

ChangeServiceReasonID

Code

ChangeServiceReasonID

Data Type

NUMBER(10)

Mandatory

No

Comment

Wartosc wybranego powodu po zmianie uslugi.


Kolumna ReasonID tabeli LPerfServiceStatus

Definicja kolumny ReasonID tabeli LPerfServiceStatus

Name

ReasonID

Code

ReasonID

Data Type

NUMBER(10)

Mandatory

No

Comment

 


Lista kluczy tabeli LPerfServiceStatus

Name

Code

Primary

Identifier_1

Identifier_1

X


Klucz Identifier_1 tabeli LPerfServiceStatus

Definicja klucza Identifier_1 tabeli LPerfServiceStatus

Name

Identifier_1

Code

Identifier_1

Primary

Yes

Comment